package com.fugood.mybigday.db;

public class SqlConstant {

	
	public class GuestInfo{
		public final static String TABLENAME = "Guest_Info";
				
		public final static String ID = "_id";
		public final static String Guest_id = "guest_id";
		public final static String NickName = "nickname";
		public final static String FirstName = "firstname";
		public final static String FamilyName = "familyname";
		public final static String Photo = "photo";
		public final static String Gender = "gender";
		public final static String Address = "address";
		public final static String Zip_code = "zip_code";
		public final static String Receiver = "receiver";
		public final static String FACEBOOK_id = "facebood_id";
		public final static String Name_Form = "name_form";
		public final static String Memorandum = "memorandum";
		public final static String FACEBOOK_username = "facebook_username";
		
		public static final String CREATETABLE =
				"create table "+ TABLENAME + " (" 
				+ ID + " integer primary key,"
				+ Guest_id + " text,"
				+ NickName + " text,"
				+ FirstName + " text,"
				+ FamilyName + " text,"
				+ Photo + " blob,"
				+ Gender + " text,"
				+ Address + " text,"
				+ Zip_code + " text,"
				+ Receiver + " text,"
				+ FACEBOOK_id + " text,"
				+ Name_Form + " text,"
				+ Memorandum + " text,"
				+ FACEBOOK_username + " text);";
		
	}
	
	
	public class GuestInfoExt{
		public final static String TABLENAME = "Guest_Info_Ext";
				
		public final static String UID = "_id";
		public final static String Guest_id = "guest_id";
		public final static String Type = "type";	//!! Type in MyBigDay is different than in GContact!!
		public final static int Title_PHONE = 1;
		public final static int Title_EMAIL = 2;	
		public final static String Title = "title";
		public final static String Value = "value";
		
		public static final String CREATETABLE =
				"create table "+ TABLENAME + " (" 
				+ UID + " integer primary key,"
				+ Guest_id + " text,"
				+ Type + " integer,"
				+ Title + " text,"
				+ Value + " text);";
		
	}
	
	public class GuestTagLink{
		public final static String TABLENAME = "Guest_Tag_Link";
				
		public final static String UID = "_id";
		public final static String Guest_id = "guest_id";
		public final static String Type_Name = "type_name";
		
		
		public static final String CREATETABLE =
				"create table "+ TABLENAME + " (" 
				+ UID + " integer primary key,"
				+ Guest_id + " text,"
				+ Type_Name + " integer	);";
		
	}
	
	public class Attendance{
		public final static String TABLENAME = "Attendance";
				
		public final static String UID = "_id";
		public final static String Guest_id = "guest_id";
		public final static String Banquet_id = "banquet_id";
		public final static String Invitor_id = "invitor_id";
		public final static String Status = "status";
		public final static String Count_of_People = "count_of_people";
		public final static String Count_of_Vegetarian = "count_of_Vege";
		public final static String Cashgift_Estimation = "cashgift_est";
		public final static String Cashgift_Amount = "cashgift_amount";
		public final static String Serial_Number = "serial_number";
				
		public static final String CREATETABLE =
				"create table "+ TABLENAME + " (" 
				+ UID + " integer primary key,"
				+ Guest_id + " text,"
				+ Banquet_id + " text,"
				+ Invitor_id + " text,"
				+ Status + " text,"
				+ Count_of_People + " integer,"
				+ Count_of_Vegetarian + " integer,"
				+ Cashgift_Estimation + " integer,"
				+ Cashgift_Amount + " integer,"
				+ Serial_Number + " text);";
		
	}
	
	
	
	public class GuestAttendLink{
		public final static String TABLENAME = "Guest_Attend_Link";
				
		public final static String UID = "_id";
		public final static String Guest_id = "guest_id";
		public final static String Banquet_id = "banquet_id";
		public final static String Attend_id = "attend_id";
		
		
		public static final String CREATETABLE =
				"create table "+ TABLENAME + " (" 
				+ UID + " integer primary key,"
				+ Guest_id + " text,"
				+ Attend_id + " text,"
				+ Banquet_id + " text);";
		
	}
	
	
	public class ContactLog{
		public final static String TABLENAME = "Contact_Log";
				
		public final static String UID = "_id";
		public final static String Guest_id = "guest_id";
		public final static String Banquet_id = "banquet_id";
		public final static String DateTime = "datetime";
		public final static String Description = "desc";
		
		
		public static final String CREATETABLE =
				"create table "+ TABLENAME + " (" 
				+ UID + " integer primary key,"
				+ Guest_id + " text,"
				+ Banquet_id + " text,"
				+ DateTime + " text,"
				+ Description + " text);";
		
	}
}
